UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ClZ9Ug3sKcfmJJCW0rwFdWz+VP1JiQEDwmTl6Ux0bF4='
WHERE
key_id = 'c7cb7f7f450d1f6db7f7a1542d87bedd2a10b21870e3b7ae7c007e9f79081403'
AND (
token = 'ClZ9Ug3sKcfmJJCW0rwFdWz+VP1JiQEDwmTl6Ux0bF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)