UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DVoThLXuhfacFMu73MHLU0Cfjai0KTa+HarNA7KOujU='
WHERE
key_id = '1a218f191554335476ef269e33e3fbaa0bbfc20beffc94c2897fb68833c0d01a'
AND (
token = 'DVoThLXuhfacFMu73MHLU0Cfjai0KTa+HarNA7KOujU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)