UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Q4ZNhDThyg6ii5udVuvSt5inOYu90NhrxdzjSsZkfL0='
WHERE
key_id = '1c642e71ad4200a6243013ac658206ab5472479d55add2704b1f70683dabf116'
AND (
token = 'Q4ZNhDThyg6ii5udVuvSt5inOYu90NhrxdzjSsZkfL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)