UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5DGo7SJsGK/A9xAFSpw3qf2J5MUPdiopM9R/W8+D7E8='
WHERE
key_id = 'd68a207e1107145c8bab3757fa843adf373c15ff1d7c03b3097039fb451df187'
AND (
token = '5DGo7SJsGK/A9xAFSpw3qf2J5MUPdiopM9R/W8+D7E8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)