UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0VEixaer16saBgnsiOHeVfMPxOx58MlE5elsRUa2byI='
WHERE
key_id = 'a9d99402869bb53b668199fd8b7cfe9b52eaefb406c4e0cd320ac00d9de9ed3d'
AND (
token = '0VEixaer16saBgnsiOHeVfMPxOx58MlE5elsRUa2byI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)