UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NHrJFSH27LKF0MzQlWKZQQ9xnntei1pl/oLbJyIGjU8='
WHERE
key_id = 'db2fcd7dedfd11293dc6ad9a1f4a61671336590e4316d9f1b0f66a31403d2540'
AND (
token = 'NHrJFSH27LKF0MzQlWKZQQ9xnntei1pl/oLbJyIGjU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)