UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W8RdiTdoZvH9veKTA0rKm1XChbdi7D7gUL9SLWDGHq0='
WHERE
key_id = '8ed827457ee6e039d81c82b43a3b3a435b9d45ec268ef03b2ebd1580263fb21b'
AND (
token = 'W8RdiTdoZvH9veKTA0rKm1XChbdi7D7gUL9SLWDGHq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)