UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NDV1A8wiYXtcAG2xO0GkhkvJdaHvngolUN+utN/e5h8='
WHERE
key_id = '40b4fc96a9ab7d63621da9d98f339bf37a502af62f584f0a28c55c52a13b9ba1'
AND (
token = 'NDV1A8wiYXtcAG2xO0GkhkvJdaHvngolUN+utN/e5h8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)