UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8RvUIw9YsKaj7PhqXBTPUZHFR4OnxVV1Y36JPD1sY9c='
WHERE
key_id = '3a6f5a8b3c6ec892981514b69804db8e7af8fa37f6a4a559590ecbdfae3d8bce'
AND (
token = '8RvUIw9YsKaj7PhqXBTPUZHFR4OnxVV1Y36JPD1sY9c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)