UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5w2ZXhE6G2ViBy3LhrFMPtVvv9ViRokKSgH5wKyh1kA='
WHERE
key_id = '29006314ed9856afc19b1447a8bde6a5d44eea6b3a1e54dc9f532ca157dac19e'
AND (
token = '5w2ZXhE6G2ViBy3LhrFMPtVvv9ViRokKSgH5wKyh1kA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)