UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LkSNYhD0LHX6jFb6Mcfl1royXldcghAxt9BEes9vpSw='
WHERE
key_id = 'c489bef2e4151f4cb4c5a674772465930ceebb5d9b9e9f6f96a25c8e755c0e9c'
AND (
token = 'LkSNYhD0LHX6jFb6Mcfl1royXldcghAxt9BEes9vpSw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)