UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JCbYM1UTr6GnbwunUJD5k6QQzqNNKKSyYZyD0643IGU='
WHERE
key_id = '918588a7e7c9c69a40c0eb24fba4683dfb9b3eba5bff95f896943900a26b2629'
AND (
token = 'JCbYM1UTr6GnbwunUJD5k6QQzqNNKKSyYZyD0643IGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)