UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WhuBuKarnkYNHHCshAoxeo6ujIBXrgmVTSE6iZbUCws='
WHERE
key_id = 'a86510aaf569ebfd5a420eec735f22db836282a3a9589bf73819d5a7c58f9d76'
AND (
token = 'WhuBuKarnkYNHHCshAoxeo6ujIBXrgmVTSE6iZbUCws='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)