UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DKz6/EVznNRu8N9hSk7AklUY76bljVvW+rAHHcEX8CA='
WHERE
key_id = '1180f49cf0600cb15a6be1a9eb82a8bf8e65e5b4789299fc7257fbe511df02fb'
AND (
token = 'DKz6/EVznNRu8N9hSk7AklUY76bljVvW+rAHHcEX8CA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)