UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0zJFeAHDqx3YIArmWvWm6zMCtlnRgwjefIBIL6jAwx8='
WHERE
key_id = '1b69806b7fc22fcf738bd922a5fb48c91089ac09154953a73fc1bf9b3a4a8cba'
AND (
token = '0zJFeAHDqx3YIArmWvWm6zMCtlnRgwjefIBIL6jAwx8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)