UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aGjVv/mKY/3k3zx2jq22fBdT9CHpyPdwH2NvWX+5FU0='
WHERE
key_id = 'bc4963b88d04953d100e0f8af01cfbe69f8a4aa90e49f8841d946215efc8a7f2'
AND (
token = 'aGjVv/mKY/3k3zx2jq22fBdT9CHpyPdwH2NvWX+5FU0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)