UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PzRw1C14qt+XzN8czmdGuNf5PPd1INKEBIq8r3v9jXs='
WHERE
key_id = 'c5bb34403bfe4f475aeb1e84e11781eb7083e60afef372cc34dc1e6ab6906e86'
AND (
token = 'PzRw1C14qt+XzN8czmdGuNf5PPd1INKEBIq8r3v9jXs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)