UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z0zxV8XsuNwZ+N0kVKSw2YtgK0esKWT9JKAVpga02lQ='
WHERE
key_id = '978a9649fef6813e9674f6e73a8827e79be5f7f475fc61d17ce6b8e2ca735cb1'
AND (
token = 'z0zxV8XsuNwZ+N0kVKSw2YtgK0esKWT9JKAVpga02lQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)