UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'v9bfx6zuFd9y45nfMZKWG3eEvs4z5KYp2ySSjTyky/c='
WHERE
key_id = 'd2716ad0f252e39133e4ed9d82f4f8f01f4d0e62972db9d05799ade702f13b12'
AND (
token = 'v9bfx6zuFd9y45nfMZKWG3eEvs4z5KYp2ySSjTyky/c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)