UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bTvg4XM+D1+423mgrUUYoaf7ho9bh1UMyqFIbfN5gss='
WHERE
key_id = 'c149cf75a6669cacc880b2e775735af572c4a73235951467d1a24635c3e3d757'
AND (
token = 'bTvg4XM+D1+423mgrUUYoaf7ho9bh1UMyqFIbfN5gss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)