UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dBajTfRxc28HKusBXXRMWAI+frzMhR0EDBEJNINDCuI='
WHERE
key_id = 'a8786da6e89db38df91d565791c1a4a4c5df8b1b073637072360a365ee7b7734'
AND (
token = 'dBajTfRxc28HKusBXXRMWAI+frzMhR0EDBEJNINDCuI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)