UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BaMGRxU3taWpyUcgWYLOYl4uUw2IBs7G9oW2xzYN5e0='
WHERE
key_id = '4fd69037dbd9ba8cd18dac3c954adc690b3b0d08d6ec28e13d25d5618ae0d29a'
AND (
token = 'BaMGRxU3taWpyUcgWYLOYl4uUw2IBs7G9oW2xzYN5e0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)