UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UXj9cSYo07GFW2kxvO1hZkI1pZ+Bocc+Sm21GV9givI='
WHERE
key_id = 'badad9f279b01785cd08a1a400e40f0e740f3f690a1dcd4ac580bd077dd76390'
AND (
token = 'UXj9cSYo07GFW2kxvO1hZkI1pZ+Bocc+Sm21GV9givI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)