UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OeyxfqsSno8R0FxrxWTklA0Uzixh3sj80PmB5aPWva0='
WHERE
key_id = 'd8610ef1e6c5434133c8c2819e2afe68d1bad78d80b7d225b86335e669b0218f'
AND (
token = 'OeyxfqsSno8R0FxrxWTklA0Uzixh3sj80PmB5aPWva0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)