UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XPn2uahmItUpPVZuVlPJsi9gGl2IsOf6ySX85k8DOe8='
WHERE
key_id = '05b5d96455b17a2e9883025130ecec940375f9402db431438073b806209dc322'
AND (
token = 'XPn2uahmItUpPVZuVlPJsi9gGl2IsOf6ySX85k8DOe8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)