UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0gyRdTEGnzvnC8mYOE0ujBJdua71stFtgSNBnxpcYOc='
WHERE
key_id = '3c22673e379214c6bf7273dcf798a19aea1999732a8610ee60c7e4e476645ac7'
AND (
token = '0gyRdTEGnzvnC8mYOE0ujBJdua71stFtgSNBnxpcYOc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)