UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oqYuJHWoUgDppE4L/0h1rUEgflisrBr5UjbICX+dPK0='
WHERE
key_id = 'de591436bbab6ceb1bc29e00654fc8fb00e1f48cd3466df28b24875caf3ef5cf'
AND (
token = 'oqYuJHWoUgDppE4L/0h1rUEgflisrBr5UjbICX+dPK0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)