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