UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5i9HPitBwEFEBRXLt9vaT5cuFZ5Ufdfsn/8M5P7PcDI='
WHERE
key_id = '8ca1da9c162e964401e171c53dbbe3fa3c6513b7754c78b77c4a33e1841ae9c7'
AND (
token = '5i9HPitBwEFEBRXLt9vaT5cuFZ5Ufdfsn/8M5P7PcDI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)