UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r9/cd/wAHtjpwWdJ+2F9osYmn6kWMIBBC9puZp41f4U='
WHERE
key_id = 'b7bc9be8ee407ff0846f324c931def3eef67d542cfa4d4652e2ba8e2cb67fdb8'
AND (
token = 'r9/cd/wAHtjpwWdJ+2F9osYmn6kWMIBBC9puZp41f4U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)