UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '29Ray9H80LjFWbu14+608yDd+jqZm3om33x9v3PE11s='
WHERE
key_id = '2066a9c8d643f264ad03b586b8619fba40b1437b14334bd399bb36a2fb527440'
AND (
token = '29Ray9H80LjFWbu14+608yDd+jqZm3om33x9v3PE11s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)