UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/N/vn36r5lZ5FmwiXUN/28iEggv5NrTQC9iQVfUSk38='
WHERE
key_id = 'b3f20d335201b2c5143783796e32f6f859da4afe1efbdfc4f003fa7b2163f6e4'
AND (
token = '/N/vn36r5lZ5FmwiXUN/28iEggv5NrTQC9iQVfUSk38='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)