UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8E9TDac6qMZ020r/J2x3VcwLtZWCteqZPCopRfePGNY='
WHERE
key_id = '6be500a8e6e0f3e2b1bd33857afdfe541e83fd822272efb49df16733922a6e9c'
AND (
token = '8E9TDac6qMZ020r/J2x3VcwLtZWCteqZPCopRfePGNY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)