UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1ZNk+uhOWLqhwkpmBeSWpOdG3SLNYQahxwyFeMXzUnU='
WHERE
key_id = 'ffd8722f3c9b554c774d0282868098f1987f568989763e40987c18f236a921b7'
AND (
token = '1ZNk+uhOWLqhwkpmBeSWpOdG3SLNYQahxwyFeMXzUnU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)