UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a9Rvmxu6DLJs9WOtReaz+5pz0ztMCGQxd1J5czE3t9k='
WHERE
key_id = '31b90051ceefb68b97b92cf78b61beb934d0ebf30b754db23d261315833a07b3'
AND (
token = 'a9Rvmxu6DLJs9WOtReaz+5pz0ztMCGQxd1J5czE3t9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)