UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pg3jdWS8wuIFmqSBzYzMNtHaSTVDr0XMkBA7OSoN2cI='
WHERE
key_id = 'b0346fa2707990f9d6684221cf58f5a538f50dc59d20c6758ee54f12a6297274'
AND (
token = 'pg3jdWS8wuIFmqSBzYzMNtHaSTVDr0XMkBA7OSoN2cI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)