UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VJUhalWvZdbz2FyE/lxx5abh7Mme4zvNDTSFLTJRKbo='
WHERE
key_id = 'a5c2344a499e8f447401b4aaad345a0121de485716abf7db5561edc532a0f998'
AND (
token = 'VJUhalWvZdbz2FyE/lxx5abh7Mme4zvNDTSFLTJRKbo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)