UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1GuTN/7yt9K9W5Ufc5as0OorHG8Fl1oKjDD3YJHnIvA='
WHERE
key_id = '0d655ca9085746e6ed5429390b9b891d7ad84af23193494edac266c0d2207eff'
AND (
token = '1GuTN/7yt9K9W5Ufc5as0OorHG8Fl1oKjDD3YJHnIvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)