UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p5suDKUH1mZMk4lqpyWQsmTMvOVO9RWQRMlIBoiWzkw='
WHERE
key_id = '10e532dd2767ab6f8d2ef40f75315d5d5f6ffdcf01daeea9bf17d584d9720356'
AND (
token = 'p5suDKUH1mZMk4lqpyWQsmTMvOVO9RWQRMlIBoiWzkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)