UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W804eJ4g9Lxt8T9zqEmiCZeBdsVpRKyGw/yBjPq1QZE='
WHERE
key_id = 'd1fe61494157e0b7fb1d348f4c68eb718ef7e23758152e579225f121ed5d6854'
AND (
token = 'W804eJ4g9Lxt8T9zqEmiCZeBdsVpRKyGw/yBjPq1QZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)