UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '74iQ221ZbAUO2nJt7WmgeCm5YVVuzyirWJmYQiOrMQo='
WHERE
key_id = 'bc9c2a31564dadfd51d67e81f28cfaf9e7d26658a93b4552179b7aca1740dacc'
AND (
token = '74iQ221ZbAUO2nJt7WmgeCm5YVVuzyirWJmYQiOrMQo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)