UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EHT9PQSU8+hFwb0XtAm4fxNfmzPrpPqKf4/XtIOHUvw='
WHERE
key_id = 'ef00c351c34f2e4998b769c3f395b052a060dccf8e542dd047dbe48422cd7966'
AND (
token = 'EHT9PQSU8+hFwb0XtAm4fxNfmzPrpPqKf4/XtIOHUvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)