UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RSM3twYbefi8Wj22Gmb4kMuC/0LVJJdF1doSAqN5CHE='
WHERE
key_id = '4a3c9d8c0b9f6313c7e693de50223a1b6ab73a4af777981cdf249e2647d3ba62'
AND (
token = 'RSM3twYbefi8Wj22Gmb4kMuC/0LVJJdF1doSAqN5CHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)