UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0KgkDR9aT9wBwXjevAvuxw5vlh0wIR8ik/3cNfpynjI='
WHERE
key_id = '5de32a0b99e155db0c33238b6627bcdde69c8d96142cafa82a35c8492e1a2a33'
AND (
token = '0KgkDR9aT9wBwXjevAvuxw5vlh0wIR8ik/3cNfpynjI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)